<?php
require_once(getabspath("classes/cipherer.php"));
$tdataDB2ADMIN_ConvenioServicio = array();
	$tdataDB2ADMIN_ConvenioServicio[".NumberOfChars"] = 80; 
	$tdataDB2ADMIN_ConvenioServicio[".ShortName"] = "DB2ADMIN_ConvenioServicio";
	$tdataDB2ADMIN_ConvenioServicio[".OwnerID"] = "";
	$tdataDB2ADMIN_ConvenioServicio[".OriginalTable"] = "DB2ADMIN.ConvenioServicio";

//	field labels
$fieldLabelsDB2ADMIN_ConvenioServicio = array();
if(mlang_getcurrentlang()=="Spanish")
{
	$fieldLabelsDB2ADMIN_ConvenioServicio["Spanish"] = array();
	$fieldToolTipsDB2ADMIN_ConvenioServicio["Spanish"] = array();
	$fieldLabelsDB2ADMIN_ConvenioServicio["Spanish"]["idConvenio"] = "Id Convenio";
	$fieldToolTipsDB2ADMIN_ConvenioServicio["Spanish"]["idConvenio"] = "";
	$fieldLabelsDB2ADMIN_ConvenioServicio["Spanish"]["idServicio"] = "Id Servicio";
	$fieldToolTipsDB2ADMIN_ConvenioServicio["Spanish"]["idServicio"] = "";
	if (count($fieldToolTipsDB2ADMIN_ConvenioServicio["Spanish"]))
		$tdataDB2ADMIN_ConvenioServicio[".isUseToolTips"] = true;
}
	
	
	$tdataDB2ADMIN_ConvenioServicio[".NCSearch"] = true;



$tdataDB2ADMIN_ConvenioServicio[".shortTableName"] = "DB2ADMIN_ConvenioServicio";
$tdataDB2ADMIN_ConvenioServicio[".nSecOptions"] = 0;
$tdataDB2ADMIN_ConvenioServicio[".recsPerRowList"] = 1;
$tdataDB2ADMIN_ConvenioServicio[".mainTableOwnerID"] = "";
$tdataDB2ADMIN_ConvenioServicio[".moveNext"] = 1;
$tdataDB2ADMIN_ConvenioServicio[".nType"] = 0;

$tdataDB2ADMIN_ConvenioServicio[".strOriginalTableName"] = "DB2ADMIN.ConvenioServicio";




$tdataDB2ADMIN_ConvenioServicio[".showAddInPopup"] = false;

$tdataDB2ADMIN_ConvenioServicio[".showEditInPopup"] = false;

$tdataDB2ADMIN_ConvenioServicio[".showViewInPopup"] = false;

$tdataDB2ADMIN_ConvenioServicio[".fieldsForRegister"] = array();

$tdataDB2ADMIN_ConvenioServicio[".listAjax"] = false;

	$tdataDB2ADMIN_ConvenioServicio[".audit"] = false;

	$tdataDB2ADMIN_ConvenioServicio[".locking"] = false;

$tdataDB2ADMIN_ConvenioServicio[".listIcons"] = true;
$tdataDB2ADMIN_ConvenioServicio[".edit"] = true;
$tdataDB2ADMIN_ConvenioServicio[".inlineEdit"] = true;
$tdataDB2ADMIN_ConvenioServicio[".inlineAdd"] = true;
$tdataDB2ADMIN_ConvenioServicio[".view"] = true;

$tdataDB2ADMIN_ConvenioServicio[".exportTo"] = true;

$tdataDB2ADMIN_ConvenioServicio[".printFriendly"] = true;

$tdataDB2ADMIN_ConvenioServicio[".delete"] = true;

$tdataDB2ADMIN_ConvenioServicio[".showSimpleSearchOptions"] = false;

$tdataDB2ADMIN_ConvenioServicio[".showSearchPanel"] = true;

if (isMobile())
	$tdataDB2ADMIN_ConvenioServicio[".isUseAjaxSuggest"] = false;
else 
	$tdataDB2ADMIN_ConvenioServicio[".isUseAjaxSuggest"] = true;

$tdataDB2ADMIN_ConvenioServicio[".rowHighlite"] = true;

// button handlers file names

$tdataDB2ADMIN_ConvenioServicio[".addPageEvents"] = false;

// use timepicker for search panel
$tdataDB2ADMIN_ConvenioServicio[".isUseTimeForSearch"] = false;




$tdataDB2ADMIN_ConvenioServicio[".allSearchFields"] = array();

$tdataDB2ADMIN_ConvenioServicio[".allSearchFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".allSearchFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".googleLikeFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".googleLikeFields"][] = "idServicio";


$tdataDB2ADMIN_ConvenioServicio[".advSearchFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".advSearchFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".isTableType"] = "list";

	



// Access doesn't support subqueries from the same table as main



$tdataDB2ADMIN_ConvenioServicio[".pageSize"] = 20;

$tstrOrderBy = "";
if(strlen($tstrOrderBy) && strtolower(substr($tstrOrderBy,0,8))!="order by")
	$tstrOrderBy = "order by ".$tstrOrderBy;
$tdataDB2ADMIN_ConvenioServicio[".strOrderBy"] = $tstrOrderBy;

$tdataDB2ADMIN_ConvenioServicio[".orderindexes"] = array();

$tdataDB2ADMIN_ConvenioServicio[".sqlHead"] = "SELECT \"idConvenio\",   \"idServicio\"";
$tdataDB2ADMIN_ConvenioServicio[".sqlFrom"] = "FROM \"DB2ADMIN\".\"ConvenioServicio\"";
$tdataDB2ADMIN_ConvenioServicio[".sqlWhereExpr"] = "";
$tdataDB2ADMIN_ConvenioServicio[".sqlTail"] = "";




//fill array of records per page for list and report without group fields
$arrRPP = array();
$arrRPP[] = 10;
$arrRPP[] = 20;
$arrRPP[] = 30;
$arrRPP[] = 50;
$arrRPP[] = 100;
$arrRPP[] = 500;
$arrRPP[] = -1;
$tdataDB2ADMIN_ConvenioServicio[".arrRecsPerPage"] = $arrRPP;

//fill array of groups per page for report with group fields
$arrGPP = array();
$arrGPP[] = 1;
$arrGPP[] = 3;
$arrGPP[] = 5;
$arrGPP[] = 10;
$arrGPP[] = 50;
$arrGPP[] = 100;
$arrGPP[] = -1;
$tdataDB2ADMIN_ConvenioServicio[".arrGroupsPerPage"] = $arrGPP;

$tableKeysDB2ADMIN_ConvenioServicio = array();
$tableKeysDB2ADMIN_ConvenioServicio[] = "idConvenio";
$tableKeysDB2ADMIN_ConvenioServicio[] = "idServicio";
$tdataDB2ADMIN_ConvenioServicio[".Keys"] = $tableKeysDB2ADMIN_ConvenioServicio;

$tdataDB2ADMIN_ConvenioServicio[".listFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".listFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".listFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".viewFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".viewFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".viewFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".addFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".addFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".addFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".inlineAddFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".inlineAddFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".inlineAddFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".editFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".editFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".editFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".inlineEditFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".inlineEditFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".inlineEditFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".exportFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".exportFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".exportFields"][] = "idServicio";

$tdataDB2ADMIN_ConvenioServicio[".printFields"] = array();
$tdataDB2ADMIN_ConvenioServicio[".printFields"][] = "idConvenio";
$tdataDB2ADMIN_ConvenioServicio[".printFields"][] = "idServicio";

//	idConvenio
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 1;
	$fdata["strName"] = "idConvenio";
	$fdata["GoodName"] = "idConvenio";
	$fdata["ownerTable"] = "DB2ADMIN.ConvenioServicio";
	$fdata["Label"] = "Id Convenio"; 
	$fdata["FieldType"] = 200;
	
		
		
		$fdata["bListPage"] = true; 
	
		$fdata["bAddPage"] = true; 
	
		$fdata["bInlineAdd"] = true; 
	
		$fdata["bEditPage"] = true; 
	
		$fdata["bInlineEdit"] = true; 
	
		$fdata["bViewPage"] = true; 
	
		$fdata["bAdvancedSearch"] = true; 
	
		$fdata["bPrinterPage"] = true; 
	
		$fdata["bExportPage"] = true; 
	
		$fdata["strField"] = "idConvenio"; 
		$fdata["FullName"] = "\"idConvenio\"";
	
		
		
				$fdata["FieldPermissions"] = true;
	
				$fdata["UploadFolder"] = "files";
		
//  Begin View Formats
	$fdata["ViewFormats"] = array();
	
	$vdata = array("ViewFormat" => "");
	
		
		
		
			
		
		
		
		
		
		
		$vdata["NeedEncode"] = true;
	
	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats 	
	$fdata["EditFormats"] = array();
	
	$edata = array("EditFormat" => "Text field");
	
		
		
	
//	Begin Lookup settings
	//	End Lookup Settings

		
		
		
		
			$edata["acceptFileTypes"] = ".+$";
	
		$edata["maxNumberOfFiles"] = 1;
	
		
		
		
		
		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";
	
		
//	Begin validation
	$edata["validateAs"] = array();
		
	//	End validation
	
		
				
		$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats
	
		$fdata["isSeparate"] = false;
	
		
		
	$tdataDB2ADMIN_ConvenioServicio["idConvenio"] = $fdata;
//	idServicio
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 2;
	$fdata["strName"] = "idServicio";
	$fdata["GoodName"] = "idServicio";
	$fdata["ownerTable"] = "DB2ADMIN.ConvenioServicio";
	$fdata["Label"] = "Id Servicio"; 
	$fdata["FieldType"] = 200;
	
		
		
		$fdata["bListPage"] = true; 
	
		$fdata["bAddPage"] = true; 
	
		$fdata["bInlineAdd"] = true; 
	
		$fdata["bEditPage"] = true; 
	
		$fdata["bInlineEdit"] = true; 
	
		$fdata["bViewPage"] = true; 
	
		$fdata["bAdvancedSearch"] = true; 
	
		$fdata["bPrinterPage"] = true; 
	
		$fdata["bExportPage"] = true; 
	
		$fdata["strField"] = "idServicio"; 
		$fdata["FullName"] = "\"idServicio\"";
	
		
		
				$fdata["FieldPermissions"] = true;
	
				$fdata["UploadFolder"] = "files";
		
//  Begin View Formats
	$fdata["ViewFormats"] = array();
	
	$vdata = array("ViewFormat" => "");
	
		
		
		
			
		
		
		
		
		
		
		$vdata["NeedEncode"] = true;
	
	$fdata["ViewFormats"]["view"] = $vdata;
//  End View Formats

//	Begin Edit Formats 	
	$fdata["EditFormats"] = array();
	
	$edata = array("EditFormat" => "Text field");
	
		
		
	
//	Begin Lookup settings
	//	End Lookup Settings

		
		
		
		
			$edata["acceptFileTypes"] = ".+$";
	
		$edata["maxNumberOfFiles"] = 1;
	
		
		
		
		
		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";
	
		
//	Begin validation
	$edata["validateAs"] = array();
		
	//	End validation
	
		
				
		$fdata["EditFormats"]["edit"] = $edata;
//	End Edit Formats
	
		$fdata["isSeparate"] = false;
	
		
		
	$tdataDB2ADMIN_ConvenioServicio["idServicio"] = $fdata;

	
$tables_data["DB2ADMIN.ConvenioServicio"]=&$tdataDB2ADMIN_ConvenioServicio;
$field_labels["DB2ADMIN_ConvenioServicio"] = &$fieldLabelsDB2ADMIN_ConvenioServicio;
$fieldToolTips["DB2ADMIN.ConvenioServicio"] = &$fieldToolTipsDB2ADMIN_ConvenioServicio;

// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["DB2ADMIN.ConvenioServicio"] = array();
	
// tables which are master tables for current table (detail)
$masterTablesData["DB2ADMIN.ConvenioServicio"] = array();

$mIndex = 1-1;
			$strOriginalDetailsTable="DB2ADMIN.Convenio";
	$masterParams["mDataSourceTable"]="DB2ADMIN.Convenio";
	$masterParams["mOriginalTable"]= $strOriginalDetailsTable;
	$masterParams["mShortTable"]= "DB2ADMIN_Convenio";
	$masterParams["masterKeys"]= array();
	$masterParams["detailKeys"]= array();
	$masterParams["dispChildCount"]= "1";
	$masterParams["hideChild"]= "0";
	$masterParams["dispInfo"]= "1";
	$masterParams["previewOnList"]= 1;
	$masterParams["previewOnAdd"]= 0;
	$masterParams["previewOnEdit"]= 0;
	$masterParams["previewOnView"]= 0;
	$masterTablesData["DB2ADMIN.ConvenioServicio"][$mIndex] = $masterParams;	
		$masterTablesData["DB2ADMIN.ConvenioServicio"][$mIndex]["masterKeys"][]="idConvenio";
		$masterTablesData["DB2ADMIN.ConvenioServicio"][$mIndex]["detailKeys"][]="idConvenio";

$mIndex = 2-1;
			$strOriginalDetailsTable="DB2ADMIN.Servicio";
	$masterParams["mDataSourceTable"]="DB2ADMIN.Servicio";
	$masterParams["mOriginalTable"]= $strOriginalDetailsTable;
	$masterParams["mShortTable"]= "DB2ADMIN_Servicio";
	$masterParams["masterKeys"]= array();
	$masterParams["detailKeys"]= array();
	$masterParams["dispChildCount"]= "1";
	$masterParams["hideChild"]= "0";
	$masterParams["dispInfo"]= "1";
	$masterParams["previewOnList"]= 1;
	$masterParams["previewOnAdd"]= 0;
	$masterParams["previewOnEdit"]= 0;
	$masterParams["previewOnView"]= 0;
	$masterTablesData["DB2ADMIN.ConvenioServicio"][$mIndex] = $masterParams;	
		$masterTablesData["DB2ADMIN.ConvenioServicio"][$mIndex]["masterKeys"][]="codigo";
		$masterTablesData["DB2ADMIN.ConvenioServicio"][$mIndex]["detailKeys"][]="idServicio";

// -----------------end  prepare master-details data arrays ------------------------------//

require_once(getabspath("classes/sql.php"));










function createSqlQuery_DB2ADMIN_ConvenioServicio()
{
$proto0=array();
$proto0["m_strHead"] = "SELECT";
$proto0["m_strFieldList"] = "\"idConvenio\",   \"idServicio\"";
$proto0["m_strFrom"] = "FROM \"DB2ADMIN\".\"ConvenioServicio\"";
$proto0["m_strWhere"] = "";
$proto0["m_strOrderBy"] = "";
$proto0["m_strTail"] = "";
$proto0["cipherer"] = null;
$proto1=array();
$proto1["m_sql"] = "";
$proto1["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto1["m_column"]=$obj;
$proto1["m_contained"] = array();
$proto1["m_strCase"] = "";
$proto1["m_havingmode"] = "0";
$proto1["m_inBrackets"] = "0";
$proto1["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto1);

$proto0["m_where"] = $obj;
$proto3=array();
$proto3["m_sql"] = "";
$proto3["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto3["m_column"]=$obj;
$proto3["m_contained"] = array();
$proto3["m_strCase"] = "";
$proto3["m_havingmode"] = "0";
$proto3["m_inBrackets"] = "0";
$proto3["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto3);

$proto0["m_having"] = $obj;
$proto0["m_fieldlist"] = array();
						$proto5=array();
			$obj = new SQLField(array(
	"m_strName" => "idConvenio",
	"m_strTable" => "DB2ADMIN.ConvenioServicio"
));

$proto5["m_expr"]=$obj;
$proto5["m_alias"] = "";
$obj = new SQLFieldListItem($proto5);

$proto0["m_fieldlist"][]=$obj;
						$proto7=array();
			$obj = new SQLField(array(
	"m_strName" => "idServicio",
	"m_strTable" => "DB2ADMIN.ConvenioServicio"
));

$proto7["m_expr"]=$obj;
$proto7["m_alias"] = "";
$obj = new SQLFieldListItem($proto7);

$proto0["m_fieldlist"][]=$obj;
$proto0["m_fromlist"] = array();
												$proto9=array();
$proto9["m_link"] = "SQLL_MAIN";
			$proto10=array();
$proto10["m_strName"] = "DB2ADMIN.ConvenioServicio";
$proto10["m_columns"] = array();
$proto10["m_columns"][] = "idConvenio";
$proto10["m_columns"][] = "idServicio";
$obj = new SQLTable($proto10);

$proto9["m_table"] = $obj;
$proto9["m_alias"] = "";
$proto11=array();
$proto11["m_sql"] = "";
$proto11["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto11["m_column"]=$obj;
$proto11["m_contained"] = array();
$proto11["m_strCase"] = "";
$proto11["m_havingmode"] = "0";
$proto11["m_inBrackets"] = "0";
$proto11["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto11);

$proto9["m_joinon"] = $obj;
$obj = new SQLFromListItem($proto9);

$proto0["m_fromlist"][]=$obj;
$proto0["m_groupby"] = array();
$proto0["m_orderby"] = array();
$obj = new SQLQuery($proto0);

	return $obj;
}
$queryData_DB2ADMIN_ConvenioServicio = createSqlQuery_DB2ADMIN_ConvenioServicio();
		$tdataDB2ADMIN_ConvenioServicio[".sqlquery"] = $queryData_DB2ADMIN_ConvenioServicio;
	
if(isset($tdataDB2ADMIN_ConvenioServicio["field2"])){
	$tdataDB2ADMIN_ConvenioServicio["field2"]["LookupTable"] = "carscars_view";
	$tdataDB2ADMIN_ConvenioServicio["field2"]["LookupOrderBy"] = "name";
	$tdataDB2ADMIN_ConvenioServicio["field2"]["LookupType"] = 4;
	$tdataDB2ADMIN_ConvenioServicio["field2"]["LinkField"] = "email";
	$tdataDB2ADMIN_ConvenioServicio["field2"]["DisplayField"] = "name";
	$tdataDB2ADMIN_ConvenioServicio[".hasCustomViewField"] = true;
}

$tableEvents["DB2ADMIN.ConvenioServicio"] = new eventsBase;
$tdataDB2ADMIN_ConvenioServicio[".hasEvents"] = false;

$cipherer = new RunnerCipherer("DB2ADMIN.ConvenioServicio");

?>